﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="dsContabilidad" targetNamespace="http://tempuri.org/dsContabilidad.xsd" xmlns:mstns="http://tempuri.org/dsContabilidad.xsd" xmlns="http://tempuri.org/dsContabilidad.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="2" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ConnectionString (MySettings)" ParameterPrefix=":" PropertyReference="ApplicationSettings.lbGlobalcom.My.MySettings.GlobalReference.Default.ConnectionString" Provider="Oracle.DataAccess.Client" />
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="ConnectionString1" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ConnectionString1 (MySettings)" ParameterPrefix=":" PropertyReference="ApplicationSettings.lbGlobalcom.My.MySettings.GlobalReference.Default.ConnectionString1" Provider="Oracle.DataAccess.Client" />
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="ConnectionString6" IsAppSettingsProperty="true" Modifier="Assembly" Name="ConnectionString6 (MySettings)" ParameterPrefix=":" PropertyReference="ApplicationSettings.lbGlobalcom.My.MySettings.GlobalReference.Default.ConnectionString6" Provider="Oracle.DataAccess.Client" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CON_CCOSTOTableAdapter" GeneratorDataComponentClassName="CON_CCOSTOTableAdapter" Name="CON_CCOSTO" UserDataComponentName="CON_CCOSTOTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.CON_CCOSTO" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "CON_CCOSTO" WHERE (("IDCCOSTO" = :Original_IDCCOSTO) AND ((:IsNull_DESCRIPCION = 1 AND "DESCRIPCION" IS NULL) OR ("DESCRIPCION" = :Original_DESCRIPCION)) AND ("TIPO" = :Original_TIPO))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCCOSTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCCOSTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRIPCION" Precision="0" ProviderType="Int32" Scale="0" Size="20" SourceColumn="DESCRIPCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_TIPO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="TIPO" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "CON_CCOSTO" ("IDCCOSTO", "DESCRIPCION", "TIPO") VALUES (:IDCCOSTO, :DESCRIPCION, :TIPO)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCCOSTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCCOSTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="TIPO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="TIPO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        IDCCOSTO, DESCRIPCION, TIPO
FROM            CON_CCOSTO</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "CON_CCOSTO" SET "IDCCOSTO" = :IDCCOSTO, "DESCRIPCION" = :DESCRIPCION, "TIPO" = :TIPO WHERE (("IDCCOSTO" = :Original_IDCCOSTO) AND ((:IsNull_DESCRIPCION = 1 AND "DESCRIPCION" IS NULL) OR ("DESCRIPCION" = :Original_DESCRIPCION)) AND ("TIPO" = :Original_TIPO))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCCOSTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCCOSTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="TIPO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="TIPO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCCOSTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCCOSTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRIPCION" Precision="0" ProviderType="Int32" Scale="0" Size="20" SourceColumn="DESCRIPCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_TIPO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="TIPO" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDCCOSTO" DataSetColumn="IDCCOSTO" />
              <Mapping SourceColumn="DESCRIPCION" DataSetColumn="DESCRIPCION" />
              <Mapping SourceColumn="TIPO" DataSetColumn="TIPO" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.CON_CCOSTO" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdCCosto" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByIdCCosto" GeneratorSourceName="FillByIdCCosto" GetMethodModifier="Public" GetMethodName="GetDataByIdCCosto" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByIdCCosto" UserSourceName="FillByIdCCosto">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT DESCRIPCION, IDCCOSTO, TIPO FROM CON_CCOSTO WHERE (IDCCOSTO = :IDCCOSTO)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="IDCCOSTO" ColumnName="IDCCOSTO" DataSourceName="SAMUEL.CON_CCOSTO" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":IDCCOSTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCCOSTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.CON_CCOSTO" DbObjectType="Table" GenerateShortCommands="true" GeneratorSourceName="GetNombreCCosto" Modifier="Public" Name="GetNombreCCosto" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="GetNombreCCosto">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        DESCRIPCION
FROM            CON_CCOSTO
WHERE        (IDCCOSTO = :IDCCOSTO)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="IDCCOSTO" ColumnName="IDCCOSTO" DataSourceName="SAMUEL.CON_CCOSTO" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":IDCCOSTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCCOSTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CON_RETENCIONTableAdapter" GeneratorDataComponentClassName="CON_RETENCIONTableAdapter" Name="CON_RETENCION" UserDataComponentName="CON_RETENCIONTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.CON_RETENCION" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "SAMUEL"."CON_RETENCION" WHERE (("IDRETENCION" = :Original_IDRETENCION) AND ((:IsNull_DESCRIPCION = 1 AND "DESCRIPCION" IS NULL) OR ("DESCRIPCION" = :Original_DESCRIPCION)) AND ((:IsNull_BASERETENCION = 1 AND "BASERETENCION" IS NULL) OR ("BASERETENCION" = :Original_BASERETENCION)) AND ((:IsNull_PORRETENCION = 1 AND "PORRETENCION" IS NULL) OR ("PORRETENCION" = :Original_PORRETENCION)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDRETENCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDRETENCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRIPCION" Precision="0" ProviderType="Int32" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_BASERETENCION" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="BASERETENCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_BASERETENCION" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="BASERETENCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PORRETENCION" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="PORRETENCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_PORRETENCION" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="PORRETENCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "SAMUEL"."CON_RETENCION" ("IDRETENCION", "DESCRIPCION", "BASERETENCION", "PORRETENCION") VALUES (:IDRETENCION, :DESCRIPCION, :BASERETENCION, :PORRETENCION)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDRETENCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDRETENCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="BASERETENCION" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="BASERETENCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="PORRETENCION" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="PORRETENCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDRETENCION, DESCRIPCION, BASERETENCION, PORRETENCION FROM SAMUEL.CON_RETENCION</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "SAMUEL"."CON_RETENCION" SET "IDRETENCION" = :IDRETENCION, "DESCRIPCION" = :DESCRIPCION, "BASERETENCION" = :BASERETENCION, "PORRETENCION" = :PORRETENCION WHERE (("IDRETENCION" = :Original_IDRETENCION) AND ((:IsNull_DESCRIPCION = 1 AND "DESCRIPCION" IS NULL) OR ("DESCRIPCION" = :Original_DESCRIPCION)) AND ((:IsNull_BASERETENCION = 1 AND "BASERETENCION" IS NULL) OR ("BASERETENCION" = :Original_BASERETENCION)) AND ((:IsNull_PORRETENCION = 1 AND "PORRETENCION" IS NULL) OR ("PORRETENCION" = :Original_PORRETENCION)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDRETENCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDRETENCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="BASERETENCION" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="BASERETENCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="PORRETENCION" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="PORRETENCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDRETENCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDRETENCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRIPCION" Precision="0" ProviderType="Int32" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_BASERETENCION" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="BASERETENCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_BASERETENCION" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="BASERETENCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PORRETENCION" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="PORRETENCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_PORRETENCION" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="PORRETENCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDRETENCION" DataSetColumn="IDRETENCION" />
              <Mapping SourceColumn="DESCRIPCION" DataSetColumn="DESCRIPCION" />
              <Mapping SourceColumn="BASERETENCION" DataSetColumn="BASERETENCION" />
              <Mapping SourceColumn="PORRETENCION" DataSetColumn="PORRETENCION" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.CON_RETENCION" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdRetencion" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByIdRetencion" GeneratorSourceName="FillByIdRetencion" GetMethodModifier="Public" GetMethodName="GetDataByIdRetencion" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByIdRetencion" UserSourceName="FillByIdRetencion">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        IDRETENCION, DESCRIPCION, BASERETENCION, PORRETENCION
FROM            CON_RETENCION
WHERE        (IDRETENCION = :IDRETEN)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="IDRETEN" ColumnName="IDRETENCION" DataSourceName="SAMUEL.CON_RETENCION" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":IDRETEN" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDRETENCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CON_TIPOIVATableAdapter" GeneratorDataComponentClassName="CON_TIPOIVATableAdapter" Name="CON_TIPOIVA" UserDataComponentName="CON_TIPOIVATableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.CON_TIPOIVA" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "SAMUEL"."CON_TIPOIVA" WHERE (("IDTIPOIVA" = :Original_IDTIPOIVA) AND ((:IsNull_DESCRIPCION = 1 AND "DESCRIPCION" IS NULL) OR ("DESCRIPCION" = :Original_DESCRIPCION)) AND ((:IsNull_PORIVA = 1 AND "PORIVA" IS NULL) OR ("PORIVA" = :Original_PORIVA)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDTIPOIVA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOIVA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRIPCION" Precision="0" ProviderType="Int32" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PORIVA" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="PORIVA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="Original_PORIVA" Precision="0" ProviderType="Single" Scale="0" Size="22" SourceColumn="PORIVA" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "SAMUEL"."CON_TIPOIVA" ("IDTIPOIVA", "DESCRIPCION", "PORIVA") VALUES (:IDTIPOIVA, :DESCRIPCION, :PORIVA)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDTIPOIVA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOIVA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="PORIVA" Precision="0" ProviderType="Single" Scale="0" Size="22" SourceColumn="PORIVA" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDTIPOIVA, DESCRIPCION, PORIVA FROM SAMUEL.CON_TIPOIVA</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "SAMUEL"."CON_TIPOIVA" SET "IDTIPOIVA" = :IDTIPOIVA, "DESCRIPCION" = :DESCRIPCION, "PORIVA" = :PORIVA WHERE (("IDTIPOIVA" = :Original_IDTIPOIVA) AND ((:IsNull_DESCRIPCION = 1 AND "DESCRIPCION" IS NULL) OR ("DESCRIPCION" = :Original_DESCRIPCION)) AND ((:IsNull_PORIVA = 1 AND "PORIVA" IS NULL) OR ("PORIVA" = :Original_PORIVA)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDTIPOIVA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOIVA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="PORIVA" Precision="0" ProviderType="Single" Scale="0" Size="22" SourceColumn="PORIVA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDTIPOIVA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOIVA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRIPCION" Precision="0" ProviderType="Int32" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PORIVA" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="PORIVA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="Original_PORIVA" Precision="0" ProviderType="Single" Scale="0" Size="22" SourceColumn="PORIVA" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDTIPOIVA" DataSetColumn="IDTIPOIVA" />
              <Mapping SourceColumn="DESCRIPCION" DataSetColumn="DESCRIPCION" />
              <Mapping SourceColumn="PORIVA" DataSetColumn="PORIVA" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.CON_TIPOIVA" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdTipoIva" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByIdTipoIva" GeneratorSourceName="FillByIdTipoIva" GetMethodModifier="Public" GetMethodName="GetDataByIdTipoIva" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByIdTipoIva" UserSourceName="FillByIdTipoIva">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        IDTIPOIVA, DESCRIPCION, PORIVA
FROM            CON_TIPOIVA
WHERE        (IDTIPOIVA = :IDTIPOIVA)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="IDTIPOIVA" ColumnName="IDTIPOIVA" DataSourceName="SAMUEL.CON_TIPOIVA" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":IDTIPOIVA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOIVA" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.CON_TIPOIVA" DbObjectType="Table" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="getNombreTipoIva" Modifier="Public" Name="getNombreTipoIva" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="getNombreTipoIva">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        DESCRIPCION
FROM            CON_TIPOIVA
WHERE        (IDTIPOIVA = :pIDTIPOIVA)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="pIDTIPOIVA" ColumnName="IDTIPOIVA" DataSourceName="SAMUEL.CON_TIPOIVA" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":pIDTIPOIVA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOIVA" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="dsContabilidad" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="dsContabilidad" msprop:Generator_DataSetName="dsContabilidad" msprop:EnableTableAdapterManager="true">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="CON_CCOSTO" msprop:Generator_UserTableName="CON_CCOSTO" msprop:Generator_RowDeletedName="CON_CCOSTORowDeleted" msprop:Generator_RowChangedName="CON_CCOSTORowChanged" msprop:Generator_RowClassName="CON_CCOSTORow" msprop:Generator_RowChangingName="CON_CCOSTORowChanging" msprop:Generator_RowEvArgName="CON_CCOSTORowChangeEvent" msprop:Generator_RowEvHandlerName="CON_CCOSTORowChangeEventHandler" msprop:Generator_TableClassName="CON_CCOSTODataTable" msprop:Generator_TableVarName="tableCON_CCOSTO" msprop:Generator_RowDeletingName="CON_CCOSTORowDeleting" msprop:Generator_TablePropName="CON_CCOSTO">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDCCOSTO" msprop:Generator_UserColumnName="IDCCOSTO" msprop:Generator_ColumnPropNameInRow="IDCCOSTO" msprop:Generator_ColumnVarNameInTable="columnIDCCOSTO" msprop:Generator_ColumnPropNameInTable="IDCCOSTOColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DESCRIPCION" msprop:Generator_UserColumnName="DESCRIPCION" msprop:Generator_ColumnPropNameInRow="DESCRIPCION" msprop:Generator_ColumnVarNameInTable="columnDESCRIPCION" msprop:Generator_ColumnPropNameInTable="DESCRIPCIONColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TIPO" msprop:Generator_UserColumnName="TIPO" msprop:Generator_ColumnPropNameInRow="TIPO" msprop:Generator_ColumnVarNameInTable="columnTIPO" msprop:Generator_ColumnPropNameInTable="TIPOColumn" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="CON_RETENCION" msprop:Generator_UserTableName="CON_RETENCION" msprop:Generator_RowDeletedName="CON_RETENCIONRowDeleted" msprop:Generator_RowChangedName="CON_RETENCIONRowChanged" msprop:Generator_RowClassName="CON_RETENCIONRow" msprop:Generator_RowChangingName="CON_RETENCIONRowChanging" msprop:Generator_RowEvArgName="CON_RETENCIONRowChangeEvent" msprop:Generator_RowEvHandlerName="CON_RETENCIONRowChangeEventHandler" msprop:Generator_TableClassName="CON_RETENCIONDataTable" msprop:Generator_TableVarName="tableCON_RETENCION" msprop:Generator_RowDeletingName="CON_RETENCIONRowDeleting" msprop:Generator_TablePropName="CON_RETENCION">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDRETENCION" msprop:Generator_UserColumnName="IDRETENCION" msprop:Generator_ColumnPropNameInRow="IDRETENCION" msprop:Generator_ColumnVarNameInTable="columnIDRETENCION" msprop:Generator_ColumnPropNameInTable="IDRETENCIONColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DESCRIPCION" msprop:Generator_UserColumnName="DESCRIPCION" msprop:Generator_ColumnPropNameInRow="DESCRIPCION" msprop:Generator_ColumnVarNameInTable="columnDESCRIPCION" msprop:Generator_ColumnPropNameInTable="DESCRIPCIONColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BASERETENCION" msprop:Generator_UserColumnName="BASERETENCION" msprop:Generator_ColumnPropNameInRow="BASERETENCION" msprop:Generator_ColumnVarNameInTable="columnBASERETENCION" msprop:Generator_ColumnPropNameInTable="BASERETENCIONColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="PORRETENCION" msprop:Generator_UserColumnName="PORRETENCION" msprop:Generator_ColumnPropNameInRow="PORRETENCION" msprop:Generator_ColumnVarNameInTable="columnPORRETENCION" msprop:Generator_ColumnPropNameInTable="PORRETENCIONColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="CON_TIPOIVA" msprop:Generator_UserTableName="CON_TIPOIVA" msprop:Generator_RowDeletedName="CON_TIPOIVARowDeleted" msprop:Generator_RowChangedName="CON_TIPOIVARowChanged" msprop:Generator_RowClassName="CON_TIPOIVARow" msprop:Generator_RowChangingName="CON_TIPOIVARowChanging" msprop:Generator_RowEvArgName="CON_TIPOIVARowChangeEvent" msprop:Generator_RowEvHandlerName="CON_TIPOIVARowChangeEventHandler" msprop:Generator_TableClassName="CON_TIPOIVADataTable" msprop:Generator_TableVarName="tableCON_TIPOIVA" msprop:Generator_RowDeletingName="CON_TIPOIVARowDeleting" msprop:Generator_TablePropName="CON_TIPOIVA">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDTIPOIVA" msprop:Generator_UserColumnName="IDTIPOIVA" msprop:Generator_ColumnPropNameInRow="IDTIPOIVA" msprop:Generator_ColumnVarNameInTable="columnIDTIPOIVA" msprop:Generator_ColumnPropNameInTable="IDTIPOIVAColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DESCRIPCION" msprop:Generator_UserColumnName="DESCRIPCION" msprop:Generator_ColumnPropNameInRow="DESCRIPCION" msprop:Generator_ColumnVarNameInTable="columnDESCRIPCION" msprop:Generator_ColumnPropNameInTable="DESCRIPCIONColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PORIVA" msprop:Generator_UserColumnName="PORIVA" msprop:Generator_ColumnPropNameInRow="PORIVA" msprop:Generator_ColumnVarNameInTable="columnPORIVA" msprop:Generator_ColumnPropNameInTable="PORIVAColumn" type="xs:float" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:CON_CCOSTO" />
      <xs:field xpath="mstns:IDCCOSTO" />
    </xs:unique>
    <xs:unique name="CON_RETENCION_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:CON_RETENCION" />
      <xs:field xpath="mstns:IDRETENCION" />
    </xs:unique>
    <xs:unique name="CON_TIPOIVA_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:CON_TIPOIVA" />
      <xs:field xpath="mstns:IDTIPOIVA" />
    </xs:unique>
  </xs:element>
</xs:schema>